﻿CREATE TABLE [dbo].[Employee_ProbationPassed] (
    [id]            INT           IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [Eid]           INT           NULL,
    [GradeId]       INT           CONSTRAINT [DF_Employee_ProbationPassed_GradeId] DEFAULT (0) NULL,
    [ZzDate]        DATETIME      NULL,
    [ProbationFrom] DATETIME      NULL,
    [ProbationTo]   DATETIME      NULL,
    [Performance]   VARCHAR (MAX) NULL,
    [Belatefor]     NVARCHAR (50) NULL,
    [EarlyOut]      NVARCHAR (50) NULL,
    [AskForLeave]   NVARCHAR (50) NULL,
    [Absenteeism]   NVARCHAR (50) NULL,
    [Proposer]      NVARCHAR (50) NULL,
    [ApplionTime]   DATETIME      NULL,
    [Audit]         BIT           CONSTRAINT [DF_Employee_ProbationPassed_Audit] DEFAULT (0) NULL,
    [Memo]          VARCHAR (MAX) NULL,
    [AuditPerson]   NVARCHAR (50) NULL,
    [AuditTime]     DATETIME      NULL,
    [IsInsured]     INT           CONSTRAINT [DF_Employee_ProbationPassed_IsInsured] DEFAULT ((2)) NULL,
    CONSTRAINT [PK_Employee_ProbationPassed] PRIMARY KEY CLUSTERED ([id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否参保  0已参保  1 未参保', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Employee_ProbationPassed', @level2type = N'COLUMN', @level2name = N'IsInsured';

